SAP Data Sources

As of Office BI Version 6.3, it's possible to connect to SAP data sources. This page contains two major sections that will help you to get up and running fast with SAP.

• SAP Connection Parameters
• SAP Example

SAP Connection Parameters

The SAP connection parameters are described below.

Mash Datasource Type

Select SAP from the drop-down list.

Site

You can select “http” or “https” based on the Theobald URL address. You need to prove the Theobald address.

Package Type

You select the package type, such as:

• Streaming CSV over HTTP
• File CSV
• OData
• SQLServer
• Oracle
• MySQL

Extraction

Different extraction items will be displayed here, based on your Package Type selection.

Username/Password

For some of the Package Types, you will be required to enter username/password.

 

SAP Example

This example shows how to define a SAP data source.

Step 1 - Connection Parameters

We click the Add Mash Data Sources button to open the "Add Mash Data Source" dialog (shown below). In this example, we fill in the dialog as follows.

• Mash Datasource Type - We select SAP from the drop-down list.
• Site - We select "http" and then type "sapdemo" to connect to the relevant SAP server.
• Package Type - We select "Streaming CSV over HTTP" from the drop-down list.
• Extraction - We select the first two items:
  • Customers (http-csv)
  • Transactions (http-csv)

Step 2 - Name

We click Next to proceed to the next dialog in the wizard (shown below). In this dialog, we type in the name and description for the data source. This is the name that will appear in both the Admin tool and the main BI Office client.

Step 3 - Roles

We click Next to proceed to the next dialog in the wizard (shown below).

To add the role names, we do as follows:

• Click Find to display role names in left column.
• Select the two role names in left column and click Add to move them to right column.

Step 4 - Finish

We click Finish to close the dialog. The new data source appears in the list.